Pandas Profiling Report

Dataset statistics

Number of variables	15
Number of observations	99003
Missing cells	177
Missing cells (%)	< 0.1%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	11.3 MiB
Average record size in memory	120.0 B

Variable types

Numeric	14
Categorical	1

Alerts

`age` is highly overall correlated with `dob_year`	High correlation
`dob_year` is highly overall correlated with `age`	High correlation
`friend_count` is highly overall correlated with `friendships_initiated` and 3 other fields	High correlation
`friendships_initiated` is highly overall correlated with `friend_count` and 2 other fields	High correlation
`likes` is highly overall correlated with `likes_received` and 4 other fields	High correlation
`likes_received` is highly overall correlated with `friend_count` and 5 other fields	High correlation
`mobile_likes` is highly overall correlated with `likes` and 3 other fields	High correlation
`mobile_likes_received` is highly overall correlated with `friend_count` and 5 other fields	High correlation
`www_likes` is highly overall correlated with `likes` and 1 other fields	High correlation
`www_likes_received` is highly overall correlated with `friend_count` and 5 other fields	High correlation
`likes_received` is highly skewed (γ1 = 112.0745682)	Skewed
`mobile_likes_received` is highly skewed (γ1 = 107.5312999)	Skewed
`www_likes_received` is highly skewed (γ1 = 126.257317)	Skewed
`userid` has unique values	Unique
`friend_count` has 1962 (2.0%) zeros	Zeros
`friendships_initiated` has 2997 (3.0%) zeros	Zeros
`likes` has 22308 (22.5%) zeros	Zeros
`likes_received` has 24428 (24.7%) zeros	Zeros
`mobile_likes` has 35056 (35.4%) zeros	Zeros
`mobile_likes_received` has 30003 (30.3%) zeros	Zeros
`www_likes` has 60999 (61.6%) zeros	Zeros
`www_likes_received` has 36864 (37.2%) zeros	Zeros

Reproduction

Analysis started	2023-08-01 00:56:48.214410
Analysis finished	2023-08-01 00:57:05.604330
Duration	17.39 seconds
Software version	ydata-profiling vv4.3.2
Download configuration	config.json

userid
Real number (ℝ)

UNIQUE

Distinct	99003
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1597045.2

Minimum	1000008
Maximum	2193542
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	773.6 KiB

Quantile statistics

Minimum	1000008
5-th percentile	1060618.3
Q1	1298805.5
median	1596148
Q3	1895744
95-th percentile	2133357.1
Maximum	2193542
Range	1193534
Interquartile range (IQR)	596938.5

Descriptive statistics

Standard deviation	344059.18
Coefficient of variation (CV)	0.21543484
Kurtosis	-1.1995568
Mean	1597045.2
Median Absolute Deviation (MAD)	298438
Skewness	0.00010766057
Sum	1.5811227 × 10¹¹
Variance	1.1837672 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2094382	1	< 0.1%
1096160	1	< 0.1%
2095762	1	< 0.1%
1910322	1	< 0.1%
1787699	1	< 0.1%
1191101	1	< 0.1%
1569326	1	< 0.1%
1077005	1	< 0.1%
1935412	1	< 0.1%
1827911	1	< 0.1%
Other values (98993)	98993	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1000008	1	< 0.1%
1000013	1	< 0.1%
1000015	1	< 0.1%
1000038	1	< 0.1%
1000059	1	< 0.1%
1000061	1	< 0.1%
1000068	1	< 0.1%
1000094	1	< 0.1%
1000103	1	< 0.1%
1000125	1	< 0.1%

Value	Count	Frequency (%)
2193542	1	< 0.1%
2193538	1	< 0.1%
2193522	1	< 0.1%
2193499	1	< 0.1%
2193485	1	< 0.1%
2193473	1	< 0.1%
2193468	1	< 0.1%
2193465	1	< 0.1%
2193460	1	< 0.1%
2193418	1	< 0.1%

age
Real number (ℝ)

HIGH CORRELATION

Distinct	101
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	37.280224

Minimum	13
Maximum	113
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	773.6 KiB

Quantile statistics

Minimum	13
5-th percentile	15
Q1	20
median	28
Q3	50
95-th percentile	90
Maximum	113
Range	100
Interquartile range (IQR)	30

Descriptive statistics

Standard deviation	22.589748
Coefficient of variation (CV)	0.60594455
Kurtosis	1.5614468
Mean	37.280224
Median Absolute Deviation (MAD)	10
Skewness	1.4152607
Sum	3690854
Variance	510.29673
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
18	5196	5.2%
23	4404	4.4%
19	4391	4.4%
20	3769	3.8%
21	3671	3.7%
25	3641	3.7%
17	3283	3.3%
16	3086	3.1%
22	3032	3.1%
24	2827	2.9%
Other values (91)	61703	62.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
13	484	0.5%
14	1925	1.9%
15	2618	2.6%
16	3086	3.1%
17	3283	3.3%
18	5196	5.2%
19	4391	4.4%
20	3769	3.8%
21	3671	3.7%
22	3032	3.1%

Value	Count	Frequency (%)
113	202	0.2%
112	18	< 0.1%
111	18	< 0.1%
110	15	< 0.1%
109	9	< 0.1%
108	1661	1.7%
107	98	0.1%
106	125	0.1%
105	80	0.1%
104	73	0.1%

dob_day
Real number (ℝ)

Distinct	31
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	14.530408

Minimum	1
Maximum	31
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	773.6 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	7
median	14
Q3	22
95-th percentile	29
Maximum	31
Range	30
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	9.0156064
Coefficient of variation (CV)	0.62046477
Kurtosis	-1.1889601
Mean	14.530408
Median Absolute Deviation (MAD)	8
Skewness	0.10784076
Sum	1438554
Variance	81.281158
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
1	7900	8.0%
10	4030	4.1%
15	3555	3.6%
5	3545	3.6%
12	3413	3.4%
2	3409	3.4%
3	3291	3.3%
17	3266	3.3%
20	3263	3.3%
14	3219	3.3%
Other values (21)	60112	60.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	7900	8.0%
2	3409	3.4%
3	3291	3.3%
4	3217	3.2%
5	3545	3.6%
6	3108	3.1%
7	3010	3.0%
8	3202	3.2%
9	3003	3.0%
10	4030	4.1%

Value	Count	Frequency (%)
31	1507	1.5%
30	2530	2.6%
29	2508	2.5%
28	2955	3.0%
27	2755	2.8%
26	2753	2.8%
25	3217	3.2%
24	2807	2.8%
23	2864	2.9%
22	2838	2.9%

dob_year
Real number (ℝ)

HIGH CORRELATION

Distinct	101
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1975.7198

Minimum	1900
Maximum	2000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	773.6 KiB

Quantile statistics

Minimum	1900
5-th percentile	1923
Q1	1963
median	1985
Q3	1993
95-th percentile	1998
Maximum	2000
Range	100
Interquartile range (IQR)	30

Descriptive statistics

Standard deviation	22.589748
Coefficient of variation (CV)	0.01143368
Kurtosis	1.5614468
Mean	1975.7198
Median Absolute Deviation (MAD)	10
Skewness	-1.4152607
Sum	1.9560218 × 10⁸
Variance	510.29673
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1995	5196	5.2%
1990	4404	4.4%
1994	4391	4.4%
1993	3769	3.8%
1992	3671	3.7%
1988	3641	3.7%
1996	3283	3.3%
1997	3086	3.1%
1991	3032	3.1%
1989	2827	2.9%
Other values (91)	61703	62.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1900	202	0.2%
1901	18	< 0.1%
1902	18	< 0.1%
1903	15	< 0.1%
1904	9	< 0.1%
1905	1661	1.7%
1906	98	0.1%
1907	125	0.1%
1908	80	0.1%
1909	73	0.1%

Value	Count	Frequency (%)
2000	484	0.5%
1999	1925	1.9%
1998	2618	2.6%
1997	3086	3.1%
1996	3283	3.3%
1995	5196	5.2%
1994	4391	4.4%
1993	3769	3.8%
1992	3671	3.7%
1991	3032	3.1%

dob_month
Real number (ℝ)

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.2833652

Minimum	1
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	773.6 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	3
median	6
Q3	9
95-th percentile	12
Maximum	12
Range	11
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	3.5296716
Coefficient of variation (CV)	0.5617486
Kurtosis	-1.2403976
Mean	6.2833652
Median Absolute Deviation (MAD)	3
Skewness	0.031295507
Sum	622072
Variance	12.458581
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
1	11772	11.9%
10	8476	8.6%
5	8271	8.4%
8	8266	8.3%
3	8110	8.2%
7	8021	8.1%
9	7939	8.0%
12	7894	8.0%
4	7810	7.9%
2	7632	7.7%
Other values (2)	14812	15.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	11772	11.9%
2	7632	7.7%
3	8110	8.2%
4	7810	7.9%
5	8271	8.4%
6	7607	7.7%
7	8021	8.1%
8	8266	8.3%
9	7939	8.0%
10	8476	8.6%

Value	Count	Frequency (%)
12	7894	8.0%
11	7205	7.3%
10	8476	8.6%
9	7939	8.0%
8	8266	8.3%
7	8021	8.1%
6	7607	7.7%
5	8271	8.4%
4	7810	7.9%
3	8110	8.2%

gender
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	175
Missing (%)	0.2%
Memory size	773.6 KiB

male	58574
female	40254

Length

Max length	6
Median length	4
Mean length	4.8146274
Min length	4

Characters and Unicode

Total characters	475820
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	male
2nd row	female
3rd row	male
4th row	female
5th row	male

Common Values

Value	Count	Frequency (%)
male	58574	59.2%
female	40254	40.7%
(Missing)	175	0.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
male	58574	59.3%
female	40254	40.7%

Most occurring characters

Value	Count	Frequency (%)
e	139082	29.2%
m	98828	20.8%
a	98828	20.8%
l	98828	20.8%
f	40254	8.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	475820	100.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	139082	29.2%
m	98828	20.8%
a	98828	20.8%
l	98828	20.8%
f	40254	8.5%

Most occurring scripts

Value	Count	Frequency (%)
Latin	475820	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	139082	29.2%
m	98828	20.8%
a	98828	20.8%
l	98828	20.8%
f	40254	8.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	475820	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	139082	29.2%
m	98828	20.8%
a	98828	20.8%
l	98828	20.8%
f	40254	8.5%

tenure
Real number (ℝ)

Distinct	2426
Distinct (%)	2.5%
Missing	2
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	537.88737

Minimum	0
Maximum	3139
Zeros	70
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	773.6 KiB

Quantile statistics

Minimum	0
5-th percentile	47
Q1	226
median	412
Q3	675
95-th percentile	1575
Maximum	3139
Range	3139
Interquartile range (IQR)	449

Descriptive statistics

Standard deviation	457.64987
Coefficient of variation (CV)	0.85082844
Kurtosis	2.1990583
Mean	537.88737
Median Absolute Deviation (MAD)	213
Skewness	1.5356809
Sum	53251388
Variance	209443.41
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
300	173	0.2%
303	170	0.2%
242	164	0.2%
272	163	0.2%
257	161	0.2%
297	161	0.2%
280	160	0.2%
285	160	0.2%
284	158	0.2%
278	158	0.2%
Other values (2416)	97373	98.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	70	0.1%
1	60	0.1%
2	72	0.1%
3	79	0.1%
4	86	0.1%
5	92	0.1%
6	93	0.1%
7	84	0.1%
8	87	0.1%
9	93	0.1%

Value	Count	Frequency (%)
3139	3	< 0.1%
3129	1	< 0.1%
3128	1	< 0.1%
3101	1	< 0.1%
3019	1	< 0.1%
2958	1	< 0.1%
2926	1	< 0.1%
2888	1	< 0.1%
2822	1	< 0.1%
2788	1	< 0.1%

friend_count
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	2562
Distinct (%)	2.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	196.35079

Minimum	0
Maximum	4923
Zeros	1962
Zeros (%)	2.0%
Negative	0
Negative (%)	0.0%
Memory size	773.6 KiB

Quantile statistics

Minimum	0
5-th percentile	3
Q1	31
median	82
Q3	206
95-th percentile	720
Maximum	4923
Range	4923
Interquartile range (IQR)	175

Descriptive statistics

Standard deviation	387.30423
Coefficient of variation (CV)	1.9725117
Kurtosis	50.094273
Mean	196.35079
Median Absolute Deviation (MAD)	64
Skewness	6.0590085
Sum	19439317
Variance	150004.57
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1962	2.0%
1	1816	1.8%
2	1117	1.1%
3	860	0.9%
5	789	0.8%
4	749	0.8%
10	737	0.7%
24	732	0.7%
6	720	0.7%
29	719	0.7%
Other values (2552)	88802	89.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1962	2.0%
1	1816	1.8%
2	1117	1.1%
3	860	0.9%
4	749	0.8%
5	789	0.8%
6	720	0.7%
7	671	0.7%
8	718	0.7%
9	700	0.7%

Value	Count	Frequency (%)
4923	1	< 0.1%
4917	1	< 0.1%
4863	1	< 0.1%
4845	1	< 0.1%
4844	1	< 0.1%
4826	1	< 0.1%
4817	1	< 0.1%
4803	1	< 0.1%
4797	1	< 0.1%
4794	1	< 0.1%

friendships_initiated
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	1519
Distinct (%)	1.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	107.45247

Minimum	0
Maximum	4144
Zeros	2997
Zeros (%)	3.0%
Negative	0
Negative (%)	0.0%
Memory size	773.6 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	17
median	46
Q3	117
95-th percentile	418
Maximum	4144
Range	4144
Interquartile range (IQR)	100

Descriptive statistics

Standard deviation	188.78695
Coefficient of variation (CV)	1.7569345
Kurtosis	42.535601
Mean	107.45247
Median Absolute Deviation (MAD)	36
Skewness	5.1507574
Sum	10638117
Variance	35640.513
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2997	3.0%
1	2212	2.2%
2	1551	1.6%
3	1355	1.4%
4	1352	1.4%
5	1328	1.3%
6	1328	1.3%
11	1319	1.3%
8	1314	1.3%
13	1279	1.3%
Other values (1509)	82968	83.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2997	3.0%
1	2212	2.2%
2	1551	1.6%
3	1355	1.4%
4	1352	1.4%
5	1328	1.3%
6	1328	1.3%
7	1237	1.2%
8	1314	1.3%
9	1245	1.3%

Value	Count	Frequency (%)
4144	1	< 0.1%
3654	1	< 0.1%
3594	1	< 0.1%
3538	1	< 0.1%
3415	1	< 0.1%
3238	1	< 0.1%
3233	1	< 0.1%
3086	1	< 0.1%
3078	1	< 0.1%
3024	1	< 0.1%

likes
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	2924
Distinct (%)	3.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	156.07879

Minimum	0
Maximum	25111
Zeros	22308
Zeros (%)	22.5%
Negative	0
Negative (%)	0.0%
Memory size	773.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	11
Q3	81
95-th percentile	726
Maximum	25111
Range	25111
Interquartile range (IQR)	80

Descriptive statistics

Standard deviation	572.28068
Coefficient of variation (CV)	3.6666141
Kurtosis	200.44569
Mean	156.07879
Median Absolute Deviation (MAD)	11
Skewness	11.023704
Sum	15452268
Variance	327505.18
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	22308	22.5%
1	6928	7.0%
2	4434	4.5%
3	3240	3.3%
4	2507	2.5%
5	2027	2.0%
6	1806	1.8%
7	1618	1.6%
8	1430	1.4%
9	1381	1.4%
Other values (2914)	51324	51.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	22308	22.5%
1	6928	7.0%
2	4434	4.5%
3	3240	3.3%
4	2507	2.5%
5	2027	2.0%
6	1806	1.8%
7	1618	1.6%
8	1430	1.4%
9	1381	1.4%

Value	Count	Frequency (%)
25111	1	< 0.1%
21652	1	< 0.1%
16732	1	< 0.1%
16583	1	< 0.1%
14799	1	< 0.1%
14355	1	< 0.1%
14050	1	< 0.1%
14039	1	< 0.1%
13692	1	< 0.1%
13622	1	< 0.1%

likes_received
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	2681
Distinct (%)	2.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	142.68936

Minimum	0
Maximum	261197
Zeros	24428
Zeros (%)	24.7%
Negative	0
Negative (%)	0.0%
Memory size	773.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	8
Q3	59
95-th percentile	561
Maximum	261197
Range	261197
Interquartile range (IQR)	58

Descriptive statistics

Standard deviation	1387.9196
Coefficient of variation (CV)	9.7268611
Kurtosis	17384.94
Mean	142.68936
Median Absolute Deviation (MAD)	8
Skewness	112.07457
Sum	14126675
Variance	1926320.9
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	24428	24.7%
1	7305	7.4%
2	4541	4.6%
3	3347	3.4%
4	2669	2.7%
5	2373	2.4%
6	1873	1.9%
7	1680	1.7%
8	1538	1.6%
9	1351	1.4%
Other values (2671)	47898	48.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	24428	24.7%
1	7305	7.4%
2	4541	4.6%
3	3347	3.4%
4	2669	2.7%
5	2373	2.4%
6	1873	1.9%
7	1680	1.7%
8	1538	1.6%
9	1351	1.4%

Value	Count	Frequency (%)
261197	1	< 0.1%
178166	1	< 0.1%
152014	1	< 0.1%
106025	1	< 0.1%
82623	1	< 0.1%
53534	1	< 0.1%
52964	1	< 0.1%
45633	1	< 0.1%
42449	1	< 0.1%
39536	1	< 0.1%

mobile_likes
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	2396
Distinct (%)	2.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	106.1163

Minimum	0
Maximum	25111
Zeros	35056
Zeros (%)	35.4%
Negative	0
Negative (%)	0.0%
Memory size	773.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	4
Q3	46
95-th percentile	481.9
Maximum	25111
Range	25111
Interquartile range (IQR)	46

Descriptive statistics

Standard deviation	445.25299
Coefficient of variation (CV)	4.1958963
Kurtosis	360.98858
Mean	106.1163
Median Absolute Deviation (MAD)	4
Skewness	14.161237
Sum	10505832
Variance	198250.22
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	35056	35.4%
1	6297	6.4%
2	3941	4.0%
3	2917	2.9%
4	2265	2.3%
5	1794	1.8%
6	1598	1.6%
7	1395	1.4%
8	1212	1.2%
9	1149	1.2%
Other values (2386)	41379	41.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	35056	35.4%
1	6297	6.4%
2	3941	4.0%
3	2917	2.9%
4	2265	2.3%
5	1794	1.8%
6	1598	1.6%
7	1395	1.4%
8	1212	1.2%
9	1149	1.2%

Value	Count	Frequency (%)
25111	1	< 0.1%
21652	1	< 0.1%
16732	1	< 0.1%
14039	1	< 0.1%
13529	1	< 0.1%
12934	1	< 0.1%
12639	1	< 0.1%
12104	1	< 0.1%
12083	1	< 0.1%
11959	1	< 0.1%

mobile_likes_received
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	2004
Distinct (%)	2.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	84.120491

Minimum	0
Maximum	138561
Zeros	30003
Zeros (%)	30.3%
Negative	0
Negative (%)	0.0%
Memory size	773.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	4
Q3	33
95-th percentile	317
Maximum	138561
Range	138561
Interquartile range (IQR)	33

Descriptive statistics

Standard deviation	839.88944
Coefficient of variation (CV)	9.9843621
Kurtosis	15522.649
Mean	84.120491
Median Absolute Deviation (MAD)	4
Skewness	107.5313
Sum	8328181
Variance	705414.28
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	30003	30.3%
1	8243	8.3%
2	4948	5.0%
3	3608	3.6%
4	2944	3.0%
5	2383	2.4%
6	2022	2.0%
7	1745	1.8%
8	1521	1.5%
9	1437	1.5%
Other values (1994)	40149	40.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	30003	30.3%
1	8243	8.3%
2	4948	5.0%
3	3608	3.6%
4	2944	3.0%
5	2383	2.4%
6	2022	2.0%
7	1745	1.8%
8	1521	1.5%
9	1437	1.5%

Value	Count	Frequency (%)
138561	1	< 0.1%
131244	1	< 0.1%
89911	1	< 0.1%
73333	1	< 0.1%
43410	1	< 0.1%
30754	1	< 0.1%
30387	1	< 0.1%
27353	1	< 0.1%
20770	1	< 0.1%
18925	1	< 0.1%

www_likes
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	1726
Distinct (%)	1.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	49.962425

Minimum	0
Maximum	14865
Zeros	60999
Zeros (%)	61.6%
Negative	0
Negative (%)	0.0%
Memory size	773.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	7
95-th percentile	208
Maximum	14865
Range	14865
Interquartile range (IQR)	7

Descriptive statistics

Standard deviation	285.56015
Coefficient of variation (CV)	5.7154982
Kurtosis	449.14848
Mean	49.962425
Median Absolute Deviation (MAD)	0
Skewness	16.911025
Sum	4946430
Variance	81544.6
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	60999	61.6%
1	4697	4.7%
2	2760	2.8%
3	1948	2.0%
4	1419	1.4%
5	1202	1.2%
6	1081	1.1%
7	897	0.9%
8	792	0.8%
9	757	0.8%
Other values (1716)	22451	22.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	60999	61.6%
1	4697	4.7%
2	2760	2.8%
3	1948	2.0%
4	1419	1.4%
5	1202	1.2%
6	1081	1.1%
7	897	0.9%
8	792	0.8%
9	757	0.8%

Value	Count	Frequency (%)
14865	1	< 0.1%
12903	1	< 0.1%
11077	1	< 0.1%
10763	1	< 0.1%
10627	1	< 0.1%
10539	1	< 0.1%
10255	1	< 0.1%
10232	1	< 0.1%
9902	1	< 0.1%
9431	1	< 0.1%

www_likes_received
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	1636
Distinct (%)	1.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	58.568831

Minimum	0
Maximum	129953
Zeros	36864
Zeros (%)	37.2%
Negative	0
Negative (%)	0.0%
Memory size	773.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	2
Q3	20
95-th percentile	227
Maximum	129953
Range	129953
Interquartile range (IQR)	20

Descriptive statistics

Standard deviation	601.41635
Coefficient of variation (CV)	10.268539
Kurtosis	23812.249
Mean	58.568831
Median Absolute Deviation (MAD)	2
Skewness	126.25732
Sum	5798490
Variance	361701.62
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	36864	37.2%
1	8513	8.6%
2	5111	5.2%
3	3586	3.6%
4	2828	2.9%
5	2317	2.3%
6	1918	1.9%
7	1602	1.6%
8	1445	1.5%
9	1373	1.4%
Other values (1626)	33446	33.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	36864	37.2%
1	8513	8.6%
2	5111	5.2%
3	3586	3.6%
4	2828	2.9%
5	2317	2.3%
6	1918	1.9%
7	1602	1.6%
8	1445	1.5%
9	1373	1.4%

Value	Count	Frequency (%)
129953	1	< 0.1%
62103	1	< 0.1%
39605	1	< 0.1%
39213	1	< 0.1%
34039	1	< 0.1%
32692	1	< 0.1%
29337	1	< 0.1%
23147	1	< 0.1%
22644	1	< 0.1%
15096	1	< 0.1%

Auto

Heatmap
Table

	userid	age	dob_day	dob_year	dob_month	tenure	friend_count	friendships_initiated	likes	likes_received	mobile_likes	mobile_likes_received	www_likes	www_likes_received	gender
userid	1.000	-0.007	-0.001	0.007	0.003	0.000	0.003	0.003	0.002	0.001	0.002	0.001	0.000	-0.001	0.004
age	-0.007	1.000	0.034	-1.000	0.029	0.341	-0.162	-0.182	0.036	0.024	-0.069	0.006	0.078	0.041	0.136
dob_day	-0.001	0.034	1.000	-0.034	0.136	0.053	0.051	0.044	0.043	0.044	0.030	0.040	0.037	0.044	0.051
dob_year	0.007	-1.000	-0.034	1.000	-0.029	-0.341	0.162	0.182	-0.036	-0.024	0.069	-0.006	-0.078	-0.041	0.137
dob_month	0.003	0.029	0.136	-0.029	1.000	0.036	0.042	0.037	0.031	0.038	0.026	0.038	0.025	0.036	0.045
tenure	0.000	0.341	0.053	-0.341	0.036	1.000	0.309	0.230	0.142	0.173	0.077	0.162	0.191	0.180	0.093
friend_count	0.003	-0.162	0.051	0.162	0.042	0.309	1.000	0.946	0.468	0.553	0.436	0.548	0.273	0.507	0.084
friendships_initiated	0.003	-0.182	0.044	0.182	0.037	0.230	0.946	1.000	0.449	0.515	0.419	0.510	0.260	0.470	0.019
likes	0.002	0.036	0.043	-0.036	0.031	0.142	0.468	0.449	1.000	0.809	0.834	0.784	0.548	0.755	0.060
likes_received	0.001	0.024	0.044	-0.024	0.038	0.173	0.553	0.515	0.809	1.000	0.697	0.965	0.461	0.924	0.009
mobile_likes	0.002	-0.069	0.030	0.069	0.026	0.077	0.436	0.419	0.834	0.697	1.000	0.730	0.171	0.591	0.042
mobile_likes_received	0.001	0.006	0.040	-0.006	0.038	0.162	0.548	0.510	0.784	0.965	0.730	1.000	0.376	0.826	0.006
www_likes	0.000	0.078	0.037	-0.078	0.025	0.191	0.273	0.260	0.548	0.461	0.171	0.376	1.000	0.541	0.052
www_likes_received	-0.001	0.041	0.044	-0.041	0.036	0.180	0.507	0.470	0.755	0.924	0.591	0.826	0.541	1.000	0.005
gender	0.004	0.136	0.051	0.137	0.045	0.093	0.084	0.019	0.060	0.009	0.042	0.006	0.052	0.005	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	userid	age	dob_day	dob_year	dob_month	gender	tenure
0	2094382	14	19	1999	11	male	266.0
1	1192601	14	2	1999	11	female	6.0
2	2083884	14	16	1999	11	male	13.0
3	1203168	14	25	1999	12	female	93.0
4	1733186	14	4	1999	12	male	82.0
5	1524765	14	1	1999	12	male	15.0
6	1136133	13	14	2000	1	male	12.0
7	1680361	13	4	2000	1	female	0.0
8	1365174	13	1	2000	1	male	81.0
9	1712567	13	2	2000	2	male	171.0

	userid	age	dob_day	dob_year	dob_month	gender	tenure	friend_count	friendships_initiated	likes	likes_received	mobile_likes	mobile_likes_received	www_likes	www_likes_received
98993	1654565	19	15	1994	8	male	394.0	4538	4144	4501	15088	4435	5961	66	9127
98994	2063006	20	4	1993	1	female	402.0	1988	332	7351	106025	7248	73333	103	32692
98995	1132164	20	9	1993	10	female	699.0	3611	973	4507	7768	4414	6909	93	859
98996	1668695	24	25	1989	4	female	182.0	2938	1272	6018	17765	5843	11708	175	6057
98997	1458985	28	14	1985	12	female	290.0	2218	1618	4626	10268	4290	4250	336	6018
98998	1268299	68	4	1945	4	female	541.0	2118	341	3996	18089	3505	11887	491	6202
98999	1256153	18	12	1995	3	female	21.0	1968	1720	4401	13412	4399	10592	2	2820
99000	1195943	15	10	1998	5	female	111.0	2002	1524	11959	12554	11959	11462	0	1092
99001	1468023	23	11	1990	4	female	416.0	2560	185	4506	6516	4506	5760	0	756
99002	1397896	39	15	1974	5	female	397.0	2049	768	9410	12443	9410	9530	0	2913

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Missing values

Sample